EMT Practice Test

1. Question Content...

---

Question1: How does Tableau know at which level to aggregate values?

Question2: You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.
Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?

Question3:

Question4: As a general best practice, how many categories can a pie chart display effectively?

Question5: Which of the following is the correct way to calculate Profit Ratio in Tableau?

Question6: You just added this field to the Columns shelf.

What will this create?

Question7: Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?

Question8: You view the relationship canvas shown in the following exhibit.

What does Migrated Data indicate?

Question9: By default, measures placed in a view are aggregated by ______________

Question10: Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Question11: Which of the following chart type makes use of 'binned' data?

Question12: You have a continuous numeric measure named Sales.
Which chart type is created when you double-click the Sales measure?

Question13: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question14: Which of the following are benefits of combining sheets using dashboards?

Question15: You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.

What should you configure for the field?

Question16: You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf.
How can you make a stacked bar chart?

Question17: Which statement accurately describes an extract when the Physical Tables option is selected?

Question18: True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

Question19: When creating a histogram in Tableau, to what does bin size refer?

Question20: Which of the following are valid use-cases for the 'Manage Metadata' functionality?

Question21: Larger image

What is this view referred to as in Tableau?

Question22: Larger image

What is this entire view referred to as in Tableau?

Question23: Relationships are represented by __________________ and operate at the ____________________.

Question24: Which statement accurately describes creating a group by selecting headers in a view?

Question25: _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Question26: Which of the following are required to create a trend line?

Question27: Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Question28: Which two types of aggregations can be applied to string fields? Choose two.

Question29: Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

Question30: In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

Question31: You have a workbook that contains one data source and you need to combine data from another database. What should you do first?

Question32: Which two statements accurately describe a visualization animation? Choose two

Question33: For a relative date filter, the default anchor is _________________

Question34: What does the following marker/icon do in Tableau?

Question35: Which two analytics options are available for a scatter plot view? Choose two.

Question36: What is the following icon in the Data pane used to do?
Larger image

Question37: Which of the following are valid Dashboard size options?

Question38: The row and column shelves contain ___________________

Question39: Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Question40: Which of the following are valid ways to italicize Tooltip content in Tableau?

Question41: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question42: You create a dashboard that tracks your teams progress on various projects. On the dashboard, you want to display your company's web page. Which dashboard element should you use?

Question43: What are two methods for renaming a field in a visualization? Choose two.

Question44: If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Question45: Which of the following shapes does a Heat Map use by default?

Question46: Which of the following are True for Measure Names?

Question47: Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

Question48: If you use a percent difference Quick Table Calculation, what value will be the first data value?

Question49: Which two filter modes can you use with dimension filters? Choose two

Question50: A dual axis chart is useful for comparing two measures that___________.

Question51: What are two correct methods for creating a visual group? Choose two.

Question52: Data blending simulates a traditional _________________ Join

Question53: True or False: The Highlighting action can be disabled for the entire workbook.

Question54: What are three options to change the scope of a reference line? Choose three.

Question55: Which of the following are correct ways to define a join in Tableau version 2020.3 and above?

Question56: _______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Question57: How can you format an axis as Bold in Tableau?

Question58: To connect Tableau to a CSV data source what type of connection should you use?

Question59: What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

Question60: True or False: When relating tables, the fields that define the relationships must have the same data type.

Question61: True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

Question62: True or False: Tableau can create worksheet-specific filters

Question63: You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

Question64: You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

Question65: Which of the following describes the best way to change the formatting at a workbook level?

Question66: The calculation [Ship Date] - [Order Date] will return _______________

Question67: Which of the following is a valid way to create Sets in Tableau?

Question68: Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Question69: You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Question70: We can join a maximum of ______ tables in Tableau

Question71: You need to display the complete list of potential data connections when you connect to a server. What action should you perform?

Question72: Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Question73: True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Question74: Which of the following are FALSE about Joins?

Question75: To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs

Question76: What are two outcomes when you drag a continuous date value to the Rows shelf? Choose two,

Question77: What are three benefits of using an extract as compared to a live connection to a data source? Choose three.

Question78: Which statement accurately describes aliases?

Question79: You can use the __________________ in Tableau to clean / organise your data.

Question80: A Tableau Support case can be opened in which of the following valid ways?

Question81: ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

Question82: What are three geographic roles that you can assign to a field? Choose three.

Question83: You have a scatter plot visualization.
What should you do to configure the visualization as a density map?

Question84: Which of the following are valid ways of Grouping Data?

Question85: What should you use to create headers in a visualization?

Question86: Which of the following returns the Absolute Value of a given number?

Question87: You want to update the font of an entire workbook.
What should you use to configure the default fonts?

Question88: Which of the following are valid Layout Container types when using Dashboards in Tableau?

Question89: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question90: What statement correctly describes a requirement to create a reference line in Tableau?

Question91: How can you add color to marks in the view in Tableau?

Question92: Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

Question93: Which of the following can you add a reference line to?

Question94: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question95: If you see the following Filter, then you're working with _______________________ Larger image

Question96: True or False: To concatenate fields, they must be of same data type

Question97: Which two options can you use to change the device layout of a dashboard? Choose two.

Question98: A union of two tables usually results in an

Question99: To use a quick table calculation, which of the following programming languages do you need to know?

Question100: What term is used to describe the following picture?

Question101: Which type of chart can you create without using a dimension?

Question102: How can you create a packaged data source?

Question103: Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Question104: True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Question105: Which type of date filter can you use to choose a range of dates based on TODAY ()?

Question106: Which two types of fields appear blue? Choose two.

Question107: What do the colours Blue and Green represent in Tableau?

Question108: Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Question109: With the Marks card drop-down menu set to Automatic, a line chart will be created whenever you place what on the Rows shelf and the Columns shelf?

Question110: Which of the following are stored in a .tds file? Choose 3.

Question111: You create the following visualization.

What is the first step to create the visual grouping of the 10 marks shown in blue?

Question112: Which of the following are benefits of using Data Extracts in Tableau?

Question113: ________________ is hosted by Tableau to share our visualisations publically with the world.

Question114: By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Question115: In which of the following scenarios would having a live connection be more beneficial than using an extract?

Question116: DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

Question117: When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Question118: Which of the following is NOT a new feature introduced in Tableau 2020.1?

Question119: For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Question120: Which of the following are compelling reasons to use a Stacked Bar Chart?

Question121: Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Question122: ________________ can only create header. _______________ will create header and axis both.

Question123: Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Question124: You have a data set that builds a union between two tables. You need to extract the data set. What should you use to extract the data set?

Question125: When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Question126: Which of the following are valid ways to show Mark Labels in the visualisation?

Question127: Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

Question128: Which two actions can you perform when you join tables from multiple connections? Choose two.

Question129: Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2) Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

Question130: How can you change the default Tableau repository location?

Question131: When using a data source that has relationships, how can you add a join between two or more tables?

Question132: Which three statements accurately describe dimensions? Choose three.

Question133: What are two correct methods to change the data type of a field? Choose two.

Question134: Which of the following points are True about Viz Animations?

Question135: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question136: __________ is a technique in Tableau which will identify marks with similar characteristics

Question137: True or False: All rows from both tables are returned in an INNER JOIN

Question138: Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.

Question139: The option to create bins is available for which type of field?

Question140: Which three elements are included in a packaged workbook (.twbx)? Choose three.

Question141: Which of the following are true about dimensions?

Question142: When viewing quick table calculations, such as Percent Difference From, that use a value in the previous column, what will be the first data value in the visualization?

Question143: Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Question144: True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.

Question145: True or False: It is possible to change the Geographic Role of a dimension